Re: Question on locking

Поиск
Список
Период
Сортировка
От M. Bastin
Тема Re: Question on locking
Дата
Msg-id a06110408bdb12fcf4347@[192.168.0.116]
обсуждение исходный текст
Ответ на Question on locking  (Steve Tucknott <steve@retsol.co.uk>)
Список pgsql-novice
Retraction of the previous (I realize SELECT FOR UPDATE can be useful
with Tom's method)

>Note: after thinking a little about it there's no need to use SELECT
>FOR UPDATE with Tom's method.  A regular UPDATE will do (it does its
>own locking all by itself for only the time needed).
>
>(Therefore, if Tom's method would be the only recommendable one, the
>command SELECT FOR UPDATE would be without purpose.  From this again
>I deduce that it originally must have been meant for use in long
>lasting transactions.)

В списке pgsql-novice по дате отправления:

Предыдущее
От: "M. Bastin"
Дата:
Сообщение: Re: Question on locking
Следующее
От: Frank Bax
Дата:
Сообщение: Re: Install 7.4.6 on Redhat 8.0 - Any issues?